Name |
|
Code |
|
Comment |
Defines medical resource model (personnel, medical equipement) |
Name |
Code |
Name |
Code |
Parent Table |
Child Table |
Foreign Key Columns |
Parent Role |
Child Role |
PerfServiceID |
|
|
||||
PersonID |
|
|
||||
PersonnelTypeID |
|
|
||||
PersonnelTypeID |
|
|
||||
EquipmentID |
|
|
||||
EquipmentTypeID |
|
|
||||
EquipmentTypeID |
|
|
||||
MedResourceID |
|
|
||||
PersonID |
|
|
||||
EquipmentID |
|
|
||||
EquipmentID |
|
|
||||
EquipmentID |
|
|
||||
ServID |
|
|
||||
UnitID |
|
|
||||
UnitID |
|
|
||||
UnitID |
|
|
||||
SpecialityID |
|
|
||||
PersonID |
|
|
||||
SpecialityID |
|
|
||||
LPersonnelTypeID |
|
|
||||
PersonID |
|
|
||||
DegreeID |
|
|
||||
DegreeID |
|
|
||||
StuffGradeID |
|
|
||||
StuffGradeID |
|
|
||||
SpecialityID |
|
|
||||
StuffGradeID |
|
|
||||
DegreeID |
|
|
||||
UnitID |
|
|
||||
SpecialityID |
|
|
||||
ExternalDoctorID |
|
|
||||
SpecialityID |
|
|
||||
StuffGradeID |
|
|
||||
EquipmentID |
|
|
||||
PerfServiceID |
|
|
||||
Per_PerfServiceID |
|
|
||||
TimeDependencyTypeID |
|
|
||||
PerfResourceID |
|
|
||||
TimeDependencyTypeID |
|
|
||||
InterpretationTypeID |
|
|
||||
SpecialityKindID |
|
|
||||
SpecialityKindID |
|
|
||||
Per_PerfResourceID |
|
|
||||
EquipmentID |
|
|
||||
PerfServiceID |
|
|
||||
UnitID |
|
|
||||
TestTubeProducerID |
|
|
||||
TestTubeTypeID |
|
|
||||
TestTubeColorID |
|
|
||||
TestTubeID |
|
|
|
|
|